﻿using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Text.RegularExpressions;
using System.Web;

namespace Web
{
    public class Helper
    {
        public static string jsonText = "{\"count\":4,\"root\":[{\"ID\":\"65\",\"ClassID\":\"19\",\"Publisher\":\"超级管理员\",\"Author\":\"河南担保公司经营许可证“门槛”细节公布\",\"Title\":\"\",\"CreateDate\":\"2011-07-03 12:04:35\"},{\"ID\":\"64\",\"ClassID\":\"19\",\"Publisher\":\"超级管理员\",\"Author\":\"郑州：担保公司争相入驻CBD金融圈\",\"Title\":\"\",\"CreateDate\":\"2011-07-03 12:04:10\"}, {\"ID\":\"63\",\"ClassID\":\"19\",\"Publisher\":\"超级管理员\",\"Author\":\"河南行业工作会议表彰“服装功勋企业家” 中报担保入选\",\"Title\":\"\",\"CreateDate\":\"2011-07-03 12:03:51\"},{\"ID\":\"62\",\"ClassID\":\"19\",\"Publisher\":\"超级管理员\",\"Author\":\"河南担保经营许可证引发河南投资担保业品牌之争\",\"Title\":\"\",\"CreateDate\":\"2011-07-03 12:03:26\"} ]}";
        //public static string jsonText = "{\"root\":[{\"colors\":\"Sony\",\"value\":7},{\"colors\":\"Samsumg\",\"value\":14},{\"colors\":\"LG\",\"value\":21},{\"colors\":\"Vizio\",\"value\":34},{\"colors\":\"Insignia\",\"value\":24}]};";
        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public static DataTable GetDt()
        {
            string providerName = "";
            string conn = String.Format(MSL.Utility.Config.Helper.GetProviderApp("Conn_Access", out providerName), @"F:\SqlServerData");

            int num = 0;
            DataTable dt = MSL.DataBase.DbHelper.Query(conn, "Articles", "ID", "ID,Content,Title", 5, 4, "1=1", " id desc", "", out num);

            return dt;

        }
    }
}